package account;
import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


import java.sql.*;

public class AccountDelete extends HttpServlet
{
	Connection conn;

	public boolean delete(String usuario, String oldPass){ 
			try
			{  
		          Class.forName("org.postgresql.Driver").newInstance();  
		    }
			catch (Exception e)
			{  
		    }  
			try {
				conn = DriverManager.getConnection("jdbc:postgresql://localhost/mc436","root","G6sAK8ea"); 
			} catch (SQLException e) {
				System.err.println("Nao foi possivel obter conexao com banco!");
				e.printStackTrace();
			}
				try{
					 Statement st0 = conn.createStatement();
			         ResultSet rs = st0.executeQuery("SELECT * FROM usuarios");
			         while (rs.next()) {
			             if(rs.getString("login").equals(usuario) && rs.getString("password").equals(oldPass))
			             {

			            	 PreparedStatement st = conn.prepareStatement("DELETE FROM usuarios WHERE login='"+usuario+"'");
			    	         st.executeUpdate();
			    	         st.close();
			    	         return true;
			             }
			         }
			         st0.close();
				
	         	
			}
			catch(Exception e){
				e.printStackTrace();
			}
			return false;
			
	}
	 
	private static final long serialVersionUID = 1L;

	public void doPost(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException 
	{
		this.doGet(request, response);
	}
	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException 
	{
		String delete = String.valueOf(request.getParameter("delete"));
		String oldPass = String.valueOf(request.getParameter("oldPass"));
		if(delete.equals("s")){
			delete(String.valueOf(request.getSession().getAttribute("userName")), oldPass);
			System.out.print(request.getSession().getAttribute("userName"));
			request.getSession().invalidate();
			
			RequestDispatcher rdIndex = request.getRequestDispatcher("index.jsp");
			rdIndex.forward(request, response);
		}
		else{
			RequestDispatcher rdIndex = request.getRequestDispatcher("index.jsp");
			rdIndex.forward(request, response);
		}
			
		
				
	}
	
	
}
 